MySQL LIMIT Clause

The LIMIT clause is used to mention the number of records to be retrieved.
The LIMIT clause is useful when there is large number of records in the table. If we retrieve all the records of a table which contains thousands of records, then it can affect the performance.

Syntax for LIMIT

select * from table_name
where condition
limit number;

Consider the below table to which we will apply the LIMIT clause.

Example

select * from employee limit 3;

We can also apply where clause along with limit clause.

select * from employee
where location='India'
 limit 3;

Output